Printing an Item Margin Report

Once you have entered all of the required information needed to generate an Item Margin Report, command options will appear allowing you to print or choose from a set of other print options.

The following information prints on the item margin report for each item both above and below the line as defined in the customer class assigned to the customer. If run by item first digit, each item first digit will have subtotals which correlate with the columns listed below. If run by category manager, each category manager, item class, and item subclass will have subtotals which correlate with the columns listed below. If run by sales category, each sales category will have subtotals that correlate with the columns listed below.

• Item – The ID and name of item sold.
• Amount Invoiced (Product) –The amount of product sold, represented in dollars.
• Amount Invoiced (Other) – The price exceptions set for customers (price allocations, cost buckets, cost adjustments, cost allocations, etc), represented in dollars.
• Amount Invoiced (Total) – Product (amount of product sold) plus Other (pricing exceptions set for customers), represented in dollars.
• Actual Cost (if report was run using actual cost) – The actual cost of the product, in dollars.
• Standard Cost (if report was run using standard cost) – The standard cost of the product, in dollars.
• Pounds – The item amount, in pounds.
• Gross Profit – Gross profit based on margin calculation formulas set in Ledger Options, represented in dollars.
• Gross Margin – Gross margin based on margin calculation formulas set in Ledger Options, represented in dollars.

Note: Each item first digit, category manager/item class/item subclass or sales category will have subtotals which correlate with the columns above.

• Total Product Above – The total dollar amount of product invoiced above the line“Above the line” refers to a customer class assigned to the customer used to segregate customers that are part of a company’s regular business. Above the line customers are generally profitable and represent sales at the normal markup..
• Total Other Above – The total dollar amount of other type items invoiced above the line.
• Grand Total Above – The grand total of product invoiced above the line, in dollars.
• Total Product Below – The total dollar amount of product invoiced below the line"Below the line” is a customer class assigned to the customer used to segregate customers that are not part of normal business. This customer class is also referred to as low margin customers or those sold at a less than normal markup..
• Total Other Below – The total dollar amount of other type items invoiced below the line.
• Grand Total Below – The grand total of products sold below the line, in dollars.
• Grand Total – The grand total of products sold above the line plus products sold below the line, in dollars.

For more information on the Item Margin Report option see Item Margin Report.

Security Required : System - Profit Margin